package rohyunji;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.List;

public class _SubDAO implements _IDAO {

	protected String	DRV="oracle.jdbc.driver.OracleDriver";
	protected String	 URL="jdbc:oracle:thin:rohji/rohji@112.216.253.125:1521:xe";
	
	
	

	public String getDRV() {
		return DRV;
	}


	public String getURL() {
		return URL;
	}




	
	
	@Override
	public Connection openDataBase() 
	{
	try
		{
			
			Class.forName(DRV);
			return DriverManager.getConnection(URL);
			
		}catch(Exception e){System.out.println("DB연동안됩니다");e.getMessage();}
		
		return null;
	}
	public void closeDataBase(Connection c, PreparedStatement p, ResultSet rs) 
	{
		if(rs!=null)try {rs.close();rs=null;} catch (Exception e) {e.printStackTrace();}
		if(p!=null)try {p.close();p=null;} catch (Exception e) {e.printStackTrace();}
		if(c!=null)try {c.close();c=null;} catch (Exception e) {e.printStackTrace();}
		
	}


	@Override
	public boolean InsertMember(MemberVO mv) {
		// TODO Auto-generated method stub
		return false;
	}


	@Override
	public List<MemberVO> SelectMember(MemberVO mv) {
		// TODO Auto-generated method stub
		return null;
	}


	@Override
	public boolean UpdateMember(MemberVO mv) {
		// TODO Auto-generated method stub
		return false;
	}


	@Override
	public int countMember(MemberVO mv) {
		// TODO Auto-generated method stub
		return 0;
	}


	public boolean InsertMember(CompanyVO c) {
		// TODO Auto-generated method stub
		return false;
	}


	@Override
	public boolean InsertCompany(CompanyVO cv) {
		// TODO Auto-generated method stub
		return false;
	}


	@Override
	public List<CompanyVO> SelectCompany(CompanyVO cv) {
		// TODO Auto-generated method stub
		return null;
	}


	@Override
	public boolean UpdateCompany(CompanyVO cv) {
		// TODO Auto-generated method stub
		return false;
	}


	@Override
	public int countCompany(CompanyVO cv) {
		// TODO Auto-generated method stub
		return 0;
	}


	@Override
	public boolean deleteCompany(CompanyVO cv) {
		// TODO Auto-generated method stub
		return false;
	}


	@Override
	public List<CompanyVO> selectCp_no(CompanyVO cv) {
		// TODO Auto-generated method stub
		return null;
	}



}
